Selecting Sort Options

To select sort options on the first field:

Click in the Sort Row under Dept


    Access displays a down arrow to the right.

Click the down arrow in the sort row


    Access displays three choices:
    ascending, and descending, or not sorted.

Click Ascending


    Access will sort this field in ascending order.

And now for the second field:

Click in the Sort Row under Descrpt


    Access displays a down arrow to the right.

Click the down arrow in the sort row

Click Ascending


    Access will sort this field in ascending order.

Your query should look like the one below:

Now your turn! Try it!